PIM Query Connector Connection Pool |
Settings
optimiseQueryForCursor
Hot setting |
Yes |
Type |
Boolean |
Description |
Optimise query for retrieving first set of records using cursor |
queryCacheSize
Hot setting |
Yes |
Type |
Integer |
Description |
Size of query cache |
precedence
Hot setting |
Yes |
Type |
String |
Description |
Data or null precedence |
requestThreshold
Hot setting |
Yes |
Type |
Long |
Description |
Threshold value for each request |
minimumWriteConnections
Hot setting |
Yes |
Type |
Integer |
Description |
Number of minimum write connections |
cursorCacheRefreshInterval
Hot setting |
Yes |
Type |
Integer |
Description |
Refresh Interval for cursor cache |
reconnectionInterval
Hot setting |
Yes |
Type |
Long |
Description |
Interval between two attempts to reconnect to the database server |
reconnectionAttempts
Hot setting |
Yes |
Type |
Integer |
Description |
Number of attempts to reconnect to the database server |
cursorCacheSize
Hot setting |
Yes |
Type |
Integer |
Description |
Size of curosr cache |
maximumWriteConnections
Hot setting |
Yes |
Type |
Integer |
Description |
Number of maximum write connections |
connectionPoolRefreshInterval
Hot setting |
Yes |
Type |
Integer |
Description |
Refresh Interval for connection Pool |
queryCacheRefreshInterval
Hot setting |
Yes |
Type |
Integer |
Description |
Refresh Interval for query cache |
allowQueryLanguageFallBack
Hot setting |
Yes |
Type |
String |
Description |
Switching query language from DBSQL to DBVIEW automatically |
conversionConfig
Hot setting |
Yes |
Type |
String |
Description |
XML structure containing data conversion info |
minimumReadConnections
Hot setting |
Yes |
Type |
Integer |
Description |
Number of minimum read connections |
multibyte
Hot setting |
Yes |
Type |
String |
Description |
Multibyte character support |
xsiNilForNullData
Hot setting |
Yes |
Type |
String |
Description |
Setting xsi:nil for absence of data along with null=true |
xmlEncoding
Hot setting |
Yes |
Type |
String |
Description |
Support for xml special characters |
maximumReadConnections
Hot setting |
Yes |
Type |
Integer |
Description |
Number of maximum read connections |
defaultCursorSize
Hot setting |
Yes |
Type |
Integer |
Description |
Default size of Cursor |
auditInfo
Hot setting |
Yes |
Type |
String |
Description |
XML structure containing audit info |
multithreaded
Hot setting |
Yes |
Type |
String |
Description |
Multithread provider support |
datasource
Hot setting |
Yes |
Type |
String |
Description |
XML structure containing datasource info |
Counters
numOfCachedReadConnections
Counter type |
Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
numOfCachedWriteConnections
Counter type |
Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
numberOfCachedQueries
Counter type |
Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
numberOfOpenCursors
Counter type |
Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
readConnectionUsageDuration
Counter type |
Event Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
readConnectionWait
Counter type |
Event Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
writeConnectionUsageDuration
Counter type |
Event Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
writeConnectionWait
Counter type |
Event Value Counter |
Value |
The number of business processes aborted because of unhandled errors since the last reset or restart of the processor. |
Hints |
|
Alerts
databaseConnectionFailure
Severity Level |
Error |
Message |
The database server may not be functioning, or the network may be encountering server connectivity problems. |
Description |
This alert is issued when connection to database server is lost. |
databaseConnectionEstablished
Severity Level |
Info |
Message |
Connection to the database Server has been established. |
Description |
This alert is issued when connection to database server is successful. |
Problems
DBConnectionFailure
problemRaiseDescription |
The database server is not available. The database server may not be functioning, or the network may be encountering server connectivity problems. Ensure that the database server is functioning, and the network is communicating properly with the server. |
problemClearDescription |
Connection to the database Server has been established. |
Sub-components
The PIM Query Connector Connection Pool type has no sub-components.